# coding=utf8
__author__ = 'zhangmike'
import xlrd
data = xlrd.open_workbook("/Users/zhangmike/Downloads/资质.xlsx")

for x in range(1, 6):
    table = data.sheets()[x]
    dt = table.col_values(1)
    dt_f = '", @"'.join(dt)
    f = open("{0}{1}".format("/Users/zhangmike/Downloads/", x), 'wr')
    f.write(dt_f.encode('utf8'))
    f.close()

